<?php

use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

class CreateCaCustomerLosses extends \App\Utils\CreateMigration
{
    function columns(Blueprint $table)
    {
        $table->unsignedBigInteger('customer_id')->default(0)->comment('客户ID');
        $table->unsignedTinyInteger('reason_id')->default(0)->comment('原因');
        $table->index(['customer_id'], 'idx_customer');
    }

    function tableInfo()
    {
        return ['ca__customer_losses', '咨询预约-客户流失原因'];
    }
}
